Configuring CheckPoint to Use Microsoft Access

SoftwareShield CheckPoint™ License Server > CheckPoint Database > Configuring CheckPoint™ to Use Microsoft Access®

## Configuring CheckPoint™ to Use Microsoft Access®

To configure the CheckPoint Server to use Microsoft Access, copy the blank database "CheckPoint.mdb" from the \SoftwareShield\CheckPoint\ directory to your server machine in a location accessible by the CheckPoint Server. This can be the same directory if you like, or any other directory.

The actual configuration is done in the License Manager using the CheckPoint License Server Remote Administrator. In the Remote Administrator, log-in to the CheckPoint server and choose to (re) configure the CheckPoint database. Note that when you do this you may have to (re) perform part of the first time set-up since the new database (if specified) may not contain a CheckPoint Administrator yet.

Once logged in you will see the current CheckPoint database configuration displayed as in the image below:

The status of the database is displayed, along with the connection string used on the server-side to connect to the database.

When you wish to change this configuration, click the "Configure..." button and the CheckPoint Database Connection Configuration dialog will appear as shown in the image below:

Be sure that you enter the location of the CheckPoint.mdb file as a relative location to the checkpoint.dll file. For example if it was located up two directories and in a sub-directory named "data", you would enter: "..\..\data\checkpoint.mdb".

When you accept the location and name, the CheckPoint Server will be contacted to make the configuration change. It will also test that the database file can be located, opened and that all the appropriate tables have been found. If any problem is encountered, the error will be reported to you.

### Microsoft Access® Permissions Issues

You may encounter the following common error when you use the Microsoft Access database with the CheckPoint License Server:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

RESOLUTION

This error is typically encountered when the CheckPoint License Server attempts to perform an UPDATE or some other action that alters the information in the database. This error occurs because ADO is unable to write to the database for one of the following reasons:

1. The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.

2. NOTE: When using the Microsoft Access databases with CheckPoint, it is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.

If you experience this error and the above does not resolve your issue, please see the Microsoft Knowledge Base Item #Q175168 at: http://support.microsoft.com/kb/q175168/

Note: The SoftwareShield CheckPoint™ License Server only comes with the Server Edition of the SoftwareShield System.